package com.example.mapper;

import com.example.entity.user.Admin;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 操作admin相关数据接口
 */
public interface AdminMapper {

    //-----新增-----

    int insert(Admin admin);

    //-----删除-----

    @Delete("delete from admin where id = #{id}")
    int deleteById(Integer id);


    //-----修改-----

    int updateById(Admin admin);


    //-----根据ID查询-----

    @Select("select * from admin where id = #{id}")
    Admin selectById(Integer id);


    //-----查询所有-----

    //SQL语句在AdminMapper.xml里面(不使用注解)
    List<Admin> selectAll(Admin admin);


    //-----用户名查询-----

    @Select("select * from admin where username = #{username}")
    Admin selectByUsername(String username);


}